Page 78 - Data_Science_Part_A C12

Solved Exercise

Objective Type Questions (Section A)

A. Tick ( ) the correct option.

1. In Calc spreadsheet software, are numbered from 1 and are numbered from A
onwards.
a. columns, rows b. columns, spreadsheet
c. rows, columns d. rows, slides

2. What is the value of the following formula?
=SUM(10,20,30,40)
a. 110 b. 100
c. 40 d. Error

3. is a collection of numerous rows and columns.
a. worksheet b. slide
c. workbook d. sidebar

4. What is the keyboard shortcut of Paste?
a. Ctrl + P b. Ctrl + C
c. Ctrl + V d. Ctrl + X

5. Which of the following does NOT exist in a slide layout in Impress?
a. Title b. Animation
c. Image d. Text Box
6. When we give ‘D12’ in a formula in Calc, we are referring to .

a. cell reference b. cell name
c. cell range d. function
7. In which menu in Impress will you find features like New Slide, Delete Slide, etc.?

a. File b. workbook
c. Insert d. Slide
8. What happens when you select a cell in Calc and type ‘=C12’ in the cell?
a. The selected cell will show the value in cell C12. b. The selected cell will be blank.
c. The selected cell will show C12 written in it. d. Error

9. In Impress, the slide that announces the topic and sets the tone for the presentation is the .
a. content slide b. master slide
c. title slide d. handout

10. Which feature in Calc helps to display data in column(s) as per specified criteria?
a. Sorting b. Filtering
c. Functions d. All of these

76 Touchpad Data Science-XII